You need to create a table that contains the fields you want to display in the opportunity. The following script creates a SQL table called OpportunityMainJob.
Note: The OpportunityKey field is required.
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[OpportunityMainJob]')
and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[OpportunityMainJob]
GO
CREATE TABLE [dbo].[OpportunityMainJob] (
[OpportuityKey] [uniqueidentifier] NOT NULL,
[JobNumber] [int] NOT NULL)
10.6 Production Release. Updated 7/20/2005 2:03:56 PM
© 2009 by Advanced Solutions International, Inc.
All rights reserved.